Dataset statistics
| Number of variables | 22 |
|---|---|
| Number of observations | 8221556 |
| Missing cells | 4 |
| Missing cells (%) | < 0.1% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 2.2 GiB |
| Average record size in memory | 284.0 B |
Variable types
| NUM | 12 |
|---|---|
| BOOL | 8 |
| CAT | 2 |
Reproduction
| Analysis started | 2020-04-22 15:07:07.288047 |
|---|---|
| Analysis finished | 2020-04-22 15:51:21.637567 |
| Version | pandas-profiling v2.6.0 |
| Command line | pandas_profiling --config_file config.yaml [YOUR_FILE.csv] |
| Download configuration | config.yaml |
FLIGHT has a high cardinality: 1352 distinct values | High cardinality |
PAR_AC_2 is highly correlated with PAR_AC_1 | High Correlation |
PAR_AC_1 is highly correlated with PAR_AC_2 | High Correlation |
PAR_AC_4 is highly correlated with PAR_AC_3 | High Correlation |
PAR_AC_3 is highly correlated with PAR_AC_4 | High Correlation |
PAR_SYS_10 is highly correlated with PAR_SYS_9 | High Correlation |
PAR_SYS_9 is highly correlated with PAR_SYS_10 | High Correlation |
PAR_SYS_6 is highly correlated with PAR_SYS_5 | High Correlation |
PAR_SYS_5 is highly correlated with PAR_SYS_6 | High Correlation |
TIME is highly skewed (γ1 = 697.5309992) | Skewed |
PAR_AC_1 has 253549 (3.1%) zeros | Zeros |
PAR_AC_2 has 260751 (3.2%) zeros | Zeros |
PAR_SYS_9 has 4339222 (52.8%) zeros | Zeros |
PAR_SYS_10 has 4330986 (52.7%) zeros | Zeros |
PAR_SYS_7 has 259639 (3.2%) zeros | Zeros |
PAR_SYS_8 has 159703 (1.9%) zeros | Zeros |
AC
Categorical
| Distinct count | 11 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 62.7 MiB |
| AC21 | |
|---|---|
| AC23 | |
| AC22 | |
| AC19 | |
| AC20 | |
| Other values (6) |
| Value | Count | Frequency (%) | |
| AC21 | 1551232 | 18.9% | |
| AC23 | 1461359 | 17.8% | |
| AC22 | 1225095 | 14.9% | |
| AC19 | 961691 | 11.7% | |
| AC20 | 693698 | 8.4% | |
| AC30 | 509333 | 6.2% | |
| AC24 | 507650 | 6.2% | |
| AC35 | 451742 | 5.5% | |
| AC36 | 370805 | 4.5% | |
| AC32 | 283229 | 3.4% |
Length
| Max length | 4 |
|---|---|
| Mean length | 4 |
| Min length | 4 |
| Value | Count | Frequency (%) | |
| Decimal_Number | 8 | 80.0% | |
| Uppercase_Letter | 2 | 20.0% |
| Value | Count | Frequency (%) | |
| Common | 8 | 80.0% | |
| Latin | 2 | 20.0% |
| Value | Count | Frequency (%) | |
| ASCII | 10 | 100.0% |
| Distinct count | 1352 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 62.7 MiB |
| 78882d | 15925 |
|---|---|
| b17ec6 | 15545 |
| f420bf | 15149 |
| 682bcd | 14905 |
| 6a86c9 | 14781 |
| Other values (1347) |
| Value | Count | Frequency (%) | |
| 78882d | 15925 | 0.2% | |
| b17ec6 | 15545 | 0.2% | |
| f420bf | 15149 | 0.2% | |
| 682bcd | 14905 | 0.2% | |
| 6a86c9 | 14781 | 0.2% | |
| 3e126d | 14765 | 0.2% | |
| 7dff94 | 14677 | 0.2% | |
| d5cb8b | 14665 | 0.2% | |
| fcfd38 | 14625 | 0.2% | |
| 7a0652 | 14361 | 0.2% | |
| Other values (1342) | 8072158 | 98.2% |
Length
| Max length | 6 |
|---|---|
| Mean length | 6 |
| Min length | 6 |
| Value | Count | Frequency (%) | |
| Decimal_Number | 10 | 62.5% | |
| Lowercase_Letter | 6 | 37.5% |
| Value | Count | Frequency (%) | |
| Common | 10 | 62.5% | |
| Latin | 6 | 37.5% |
| Value | Count | Frequency (%) | |
| ASCII | 16 | 100.0% |
| Distinct count | 47624 |
|---|---|
| Unique (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7378.576313 |
|---|---|
| Minimum | 0 |
| Maximum | 31536002 |
| Zeros | 1356 |
| Zeros (%) | < 0.1% |
| Memory size | 62.7 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1035 |
| Q1 | 3056 |
| median | 4783 |
| Q3 | 6971 |
| 95-th percentile | 12084 |
| Maximum | 31536002 |
| Range | 31536002 |
| Interquartile range (IQR) | 3915 |
Descriptive statistics
| Standard deviation | 17635.89212 |
|---|---|
| Coefficient of variation (CV) | 2.390148366 |
| Kurtosis | 1242452.129 |
| Mean | 7378.576313 |
| Median Absolute Deviation (MAD) | 5296.622469 |
| Skewness | 697.5309992 |
| Sum | 6.066337836e+10 |
| Variance | 311024690.9 |
| Value | Count | Frequency (%) | |
| 0 | 1356 | < 0.1% | |
| 3599 | 1293 | < 0.1% | |
| 3609 | 1259 | < 0.1% | |
| 3597 | 1259 | < 0.1% | |
| 3598 | 1259 | < 0.1% | |
| 3591 | 1258 | < 0.1% | |
| 3593 | 1258 | < 0.1% | |
| 3611 | 1258 | < 0.1% | |
| 3590 | 1257 | < 0.1% | |
| 3595 | 1257 | < 0.1% | |
| Other values (47614) | 8208842 | 99.8% |
| Value | Count | Frequency (%) | |
| 0 | 1356 | < 0.1% | |
| 1 | 908 | < 0.1% | |
| 2 | 572 | < 0.1% | |
| 3 | 229 | < 0.1% | |
| 4 | 142 | < 0.1% |
| Value | Count | Frequency (%) | |
| 31536002 | 1 | < 0.1% | |
| 100088 | 1 | < 0.1% | |
| 100087 | 1 | < 0.1% | |
| 100086 | 1 | < 0.1% | |
| 100085 | 1 | < 0.1% |
AMBIENT_1
Real number (ℝ)
| Distinct count | 81239 |
|---|---|
| Unique (%) | 1.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 34542.41204 |
|---|---|
| Minimum | -831 |
| Maximum | 71392 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 62.7 MiB |
Quantile statistics
| Minimum | -831 |
|---|---|
| 5-th percentile | 11922 |
| Q1 | 17975.5 |
| median | 40569 |
| Q3 | 48055 |
| 95-th percentile | 50107.5 |
| Maximum | 71392 |
| Range | 72223 |
| Interquartile range (IQR) | 30079.5 |
Descriptive statistics
| Standard deviation | 15019.20515 |
|---|---|
| Coefficient of variation (CV) | 0.4348047591 |
| Kurtosis | -1.516863706 |
| Mean | 34542.41204 |
| Median Absolute Deviation (MAD) | 13798.68256 |
| Skewness | -0.4103348137 |
| Sum | 2.83992375e+11 |
| Variance | 225576523.2 |
| Value | Count | Frequency (%) | |
| 47998 | 71922 | 0.9% | |
| 47999 | 42649 | 0.5% | |
| 47999.5 | 41722 | 0.5% | |
| 47998.5 | 41640 | 0.5% | |
| 48000 | 39170 | 0.5% | |
| 48000.5 | 34937 | 0.4% | |
| 49999 | 33504 | 0.4% | |
| 49999.5 | 32681 | 0.4% | |
| 49998.5 | 31726 | 0.4% | |
| 50000 | 31512 | 0.4% | |
| Other values (81229) | 7820093 | 95.1% |
| Value | Count | Frequency (%) | |
| -831 | 2 | < 0.1% | |
| 3905 | 2 | < 0.1% | |
| 4272 | 1 | < 0.1% | |
| 5185 | 2 | < 0.1% | |
| 5856 | 29 | < 0.1% |
| Value | Count | Frequency (%) | |
| 71392 | 5 | < 0.1% | |
| 53011.5 | 1 | < 0.1% | |
| 53010.5 | 1 | < 0.1% | |
| 53010 | 3 | < 0.1% | |
| 53009.5 | 5 | < 0.1% |
| Distinct count | 699 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 91.0096417 |
|---|---|
| Minimum | 0 |
| Maximum | 129.63625 |
| Zeros | 253549 |
| Zeros (%) | 3.1% |
| Memory size | 62.7 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 29.455 |
| Q1 | 56.17 |
| median | 115.4225 |
| Q3 | 119.19 |
| 95-th percentile | 126.89625 |
| Maximum | 129.63625 |
| Range | 129.63625 |
| Interquartile range (IQR) | 63.02 |
Descriptive statistics
| Standard deviation | 38.11192096 |
|---|---|
| Coefficient of variation (CV) | 0.4187679486 |
| Kurtosis | -0.8039133559 |
| Mean | 91.0096417 |
| Median Absolute Deviation (MAD) | 34.37121645 |
| Skewness | -0.8230965291 |
| Sum | 748240865.7 |
| Variance | 1452.518519 |
| Value | Count | Frequency (%) | |
| 0 | 253549 | 3.1% | |
| 117.4775 | 105138 | 1.3% | |
| 117.64875 | 104739 | 1.3% | |
| 117.82 | 104729 | 1.3% | |
| 117.30625 | 104457 | 1.3% | |
| 117.99125 | 104267 | 1.3% | |
| 117.135 | 104042 | 1.3% | |
| 118.1625 | 103139 | 1.3% | |
| 116.96375 | 102984 | 1.3% | |
| 116.7925 | 99819 | 1.2% | |
| Other values (689) | 7034693 | 85.6% |
| Value | Count | Frequency (%) | |
| 0 | 253549 | 3.1% | |
| 10.275 | 399 | < 0.1% | |
| 10.44625 | 568 | < 0.1% | |
| 10.6175 | 599 | < 0.1% | |
| 10.78875 | 571 | < 0.1% |
| Value | Count | Frequency (%) | |
| 129.63625 | 4 | < 0.1% | |
| 129.465 | 73 | < 0.1% | |
| 129.29375 | 1141 | < 0.1% | |
| 129.1225 | 9243 | 0.1% | |
| 128.95125 | 28492 | 0.3% |
| Distinct count | 705 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 90.90196443 |
|---|---|
| Minimum | -276.74 |
| Maximum | 262.355 |
| Zeros | 260751 |
| Zeros (%) | 3.2% |
| Memory size | 62.7 MiB |
Quantile statistics
| Minimum | -276.74 |
|---|---|
| 5-th percentile | 29.28375 |
| Q1 | 56.17 |
| median | 115.4225 |
| Q3 | 119.19 |
| 95-th percentile | 126.89625 |
| Maximum | 262.355 |
| Range | 539.095 |
| Interquartile range (IQR) | 63.02 |
Descriptive statistics
| Standard deviation | 38.27212114 |
|---|---|
| Coefficient of variation (CV) | 0.4210263374 |
| Kurtosis | -0.800836377 |
| Mean | 90.90196443 |
| Median Absolute Deviation (MAD) | 34.4994654 |
| Skewness | -0.8251029976 |
| Sum | 747355591.1 |
| Variance | 1464.755257 |
| Value | Count | Frequency (%) | |
| 0 | 260751 | 3.2% | |
| 117.82 | 105037 | 1.3% | |
| 117.4775 | 104843 | 1.3% | |
| 117.30625 | 104556 | 1.3% | |
| 117.64875 | 104546 | 1.3% | |
| 117.135 | 104266 | 1.3% | |
| 117.99125 | 104182 | 1.3% | |
| 118.1625 | 103233 | 1.3% | |
| 116.96375 | 102560 | 1.2% | |
| 116.7925 | 100138 | 1.2% | |
| Other values (695) | 7027444 | 85.5% |
| Value | Count | Frequency (%) | |
| -276.74 | 2 | < 0.1% | |
| -57.54 | 2 | < 0.1% | |
| -13.7 | 2 | < 0.1% | |
| 0 | 260751 | 3.2% | |
| 0.3425 | 3 | < 0.1% |
| Value | Count | Frequency (%) | |
| 262.355 | 1 | < 0.1% | |
| 129.8075 | 1 | < 0.1% | |
| 129.63625 | 2 | < 0.1% | |
| 129.465 | 38 | < 0.1% | |
| 129.29375 | 1044 | < 0.1% |
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 62.7 MiB |
| 0 | |
|---|---|
| 1 | 80017 |
| Value | Count | Frequency (%) | |
| 0 | 8141539 | 99.0% | |
| 1 | 80017 | 1.0% |
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 62.7 MiB |
| 0 | |
|---|---|
| 1 | 80011 |
| Value | Count | Frequency (%) | |
| 0 | 8141545 | 99.0% | |
| 1 | 80011 | 1.0% |
PAR_SYS_1
Real number (ℝ≥0)
| Distinct count | 713 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 56.11225194 |
|---|---|
| Minimum | 20 |
| Maximum | 149.25 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 62.7 MiB |
Quantile statistics
| Minimum | 20 |
|---|---|
| 5-th percentile | 42 |
| Q1 | 54 |
| median | 55.375 |
| Q3 | 60 |
| 95-th percentile | 67 |
| Maximum | 149.25 |
| Range | 129.25 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 7.218618777 |
|---|---|
| Coefficient of variation (CV) | 0.1286460359 |
| Kurtosis | 3.226073251 |
| Mean | 56.11225194 |
| Median Absolute Deviation (MAD) | 4.840167217 |
| Skewness | -0.6656633492 |
| Sum | 461330021.6 |
| Variance | 52.10845705 |
| Value | Count | Frequency (%) | |
| 54.75 | 223297 | 2.7% | |
| 54.5 | 201833 | 2.5% | |
| 55 | 198114 | 2.4% | |
| 55.125 | 197735 | 2.4% | |
| 54.375 | 192950 | 2.3% | |
| 54.125 | 192572 | 2.3% | |
| 55.375 | 191559 | 2.3% | |
| 54.625 | 181887 | 2.2% | |
| 54.875 | 180888 | 2.2% | |
| 55.25 | 167669 | 2.0% | |
| Other values (703) | 6293052 | 76.5% |
| Value | Count | Frequency (%) | |
| 20 | 2845 | < 0.1% | |
| 20.125 | 356 | < 0.1% | |
| 20.25 | 354 | < 0.1% | |
| 20.375 | 434 | < 0.1% | |
| 20.5 | 578 | < 0.1% |
| Value | Count | Frequency (%) | |
| 149.25 | 4 | < 0.1% | |
| 146.375 | 4 | < 0.1% | |
| 146.125 | 4 | < 0.1% | |
| 145 | 4 | < 0.1% | |
| 138.75 | 4 | < 0.1% |
PAR_SYS_2
Real number (ℝ≥0)
| Distinct count | 238 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 2 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 311.8746598 |
|---|---|
| Minimum | 122 |
| Maximum | 382 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 62.7 MiB |
Quantile statistics
| Minimum | 122 |
|---|---|
| 5-th percentile | 255 |
| Q1 | 309 |
| median | 320 |
| Q3 | 326 |
| 95-th percentile | 335 |
| Maximum | 382 |
| Range | 260 |
| Interquartile range (IQR) | 17 |
Descriptive statistics
| Standard deviation | 26.42852368 |
|---|---|
| Coefficient of variation (CV) | 0.08474084973 |
| Kurtosis | 6.545088119 |
| Mean | 311.8746598 |
| Median Absolute Deviation (MAD) | 17.87202457 |
| Skewness | -2.314777009 |
| Sum | 2564094357 |
| Variance | 698.466864 |
| Value | Count | Frequency (%) | |
| 322 | 429958 | 5.2% | |
| 323 | 380790 | 4.6% | |
| 324 | 376991 | 4.6% | |
| 325 | 350757 | 4.3% | |
| 321 | 335126 | 4.1% | |
| 320 | 327262 | 4.0% | |
| 326 | 318893 | 3.9% | |
| 327 | 308289 | 3.7% | |
| 328 | 276292 | 3.4% | |
| 319 | 267449 | 3.3% | |
| Other values (228) | 4849747 | 59.0% |
| Value | Count | Frequency (%) | |
| 122 | 2 | < 0.1% | |
| 138 | 48 | < 0.1% | |
| 139 | 5 | < 0.1% | |
| 140 | 64 | < 0.1% | |
| 141 | 148 | < 0.1% |
| Value | Count | Frequency (%) | |
| 382 | 4 | < 0.1% | |
| 381 | 4 | < 0.1% | |
| 372 | 12 | < 0.1% | |
| 371 | 44 | < 0.1% | |
| 370 | 64 | < 0.1% |
PAR_SYS_3
Real number (ℝ)
| Distinct count | 709 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 55.67084327 |
|---|---|
| Minimum | -219.625 |
| Maximum | 156.5 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 62.7 MiB |
Quantile statistics
| Minimum | -219.625 |
|---|---|
| 5-th percentile | 41.75 |
| Q1 | 54 |
| median | 55.25 |
| Q3 | 59.25 |
| 95-th percentile | 66.5 |
| Maximum | 156.5 |
| Range | 376.125 |
| Interquartile range (IQR) | 5.25 |
Descriptive statistics
| Standard deviation | 7.456876626 |
|---|---|
| Coefficient of variation (CV) | 0.1339458177 |
| Kurtosis | 4.581991927 |
| Mean | 55.67084327 |
| Median Absolute Deviation (MAD) | 4.827394936 |
| Skewness | -0.8733125774 |
| Sum | 457700955.5 |
| Variance | 55.60500902 |
| Value | Count | Frequency (%) | |
| 54.75 | 222447 | 2.7% | |
| 54.5 | 211280 | 2.6% | |
| 55.125 | 202387 | 2.5% | |
| 54.125 | 202368 | 2.5% | |
| 55 | 200938 | 2.4% | |
| 54.375 | 196910 | 2.4% | |
| 55.375 | 194179 | 2.4% | |
| 54.875 | 183920 | 2.2% | |
| 54.625 | 182479 | 2.2% | |
| 54.25 | 176477 | 2.1% | |
| Other values (699) | 6248171 | 76.0% |
| Value | Count | Frequency (%) | |
| -219.625 | 4 | < 0.1% | |
| -119.875 | 5 | < 0.1% | |
| -33.75 | 5 | < 0.1% | |
| -23.875 | 10 | < 0.1% | |
| 20 | 2397 | < 0.1% |
| Value | Count | Frequency (%) | |
| 156.5 | 4 | < 0.1% | |
| 156 | 4 | < 0.1% | |
| 155.75 | 4 | < 0.1% | |
| 155.625 | 4 | < 0.1% | |
| 155.25 | 8 | < 0.1% |
PAR_SYS_4
Real number (ℝ≥0)
| Distinct count | 234 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 311.8745313 |
|---|---|
| Minimum | 120 |
| Maximum | 378 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 62.7 MiB |
Quantile statistics
| Minimum | 120 |
|---|---|
| 5-th percentile | 249 |
| Q1 | 310 |
| median | 321 |
| Q3 | 326 |
| 95-th percentile | 335 |
| Maximum | 378 |
| Range | 258 |
| Interquartile range (IQR) | 16 |
Descriptive statistics
| Standard deviation | 27.6604775 |
|---|---|
| Coefficient of variation (CV) | 0.08869104312 |
| Kurtosis | 6.829035816 |
| Mean | 311.8745313 |
| Median Absolute Deviation (MAD) | 18.21603561 |
| Skewness | -2.452484021 |
| Sum | 2564093924 |
| Variance | 765.1020157 |
| Value | Count | Frequency (%) | |
| 322 | 486044 | 5.9% | |
| 323 | 460310 | 5.6% | |
| 324 | 444135 | 5.4% | |
| 325 | 394700 | 4.8% | |
| 321 | 381826 | 4.6% | |
| 320 | 365355 | 4.4% | |
| 326 | 337416 | 4.1% | |
| 327 | 312215 | 3.8% | |
| 319 | 280733 | 3.4% | |
| 328 | 257711 | 3.1% | |
| Other values (224) | 4501111 | 54.7% |
| Value | Count | Frequency (%) | |
| 120 | 1 | < 0.1% | |
| 140 | 76 | < 0.1% | |
| 141 | 146 | < 0.1% | |
| 142 | 144 | < 0.1% | |
| 143 | 174 | < 0.1% |
| Value | Count | Frequency (%) | |
| 378 | 4 | < 0.1% | |
| 371 | 20 | < 0.1% | |
| 370 | 64 | < 0.1% | |
| 369 | 92 | < 0.1% | |
| 368 | 184 | < 0.1% |
WAR_SYS_1
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 62.7 MiB |
| 0 | |
|---|---|
| 1 | 131 |
| Value | Count | Frequency (%) | |
| 0 | 8221425 | > 99.9% | |
| 1 | 131 | < 0.1% |
COM_SYS_1
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 62.7 MiB |
| 0 | |
|---|---|
| 1 | 1081 |
| Value | Count | Frequency (%) | |
| 0 | 8220475 | > 99.9% | |
| 1 | 1081 | < 0.1% |
| Distinct count | 102 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.117964574 |
|---|---|
| Minimum | -6 |
| Maximum | 7.5 |
| Zeros | 4339222 |
| Zeros (%) | 52.8% |
| Memory size | 62.7 MiB |
Quantile statistics
| Minimum | -6 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 3.6 |
| 95-th percentile | 6.45 |
| Maximum | 7.5 |
| Range | 13.5 |
| Interquartile range (IQR) | 3.6 |
Descriptive statistics
| Standard deviation | 2.409542962 |
|---|---|
| Coefficient of variation (CV) | 1.137669153 |
| Kurtosis | -1.213266635 |
| Mean | 2.117964574 |
| Median Absolute Deviation (MAD) | 2.23598504 |
| Skewness | 0.5373590427 |
| Sum | 17412964.35 |
| Variance | 5.805897286 |
| Value | Count | Frequency (%) | |
| 0 | 4339222 | 52.8% | |
| 3.45 | 519495 | 6.3% | |
| 3.375 | 475641 | 5.8% | |
| 3.525 | 449240 | 5.5% | |
| 3.6 | 272144 | 3.3% | |
| 6.525 | 235623 | 2.9% | |
| 6.15 | 206274 | 2.5% | |
| 3.75 | 192618 | 2.3% | |
| 3.675 | 192229 | 2.3% | |
| 6.075 | 180503 | 2.2% | |
| Other values (92) | 1158567 | 14.1% |
| Value | Count | Frequency (%) | |
| -6 | 2 | < 0.1% | |
| -1.2 | 2 | < 0.1% | |
| 0 | 4339222 | 52.8% | |
| 0.075 | 4 | < 0.1% | |
| 0.15 | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| 7.5 | 43 | < 0.1% | |
| 7.425 | 26 | < 0.1% | |
| 7.35 | 33 | < 0.1% | |
| 7.275 | 40 | < 0.1% | |
| 7.2 | 56 | < 0.1% |
| Distinct count | 106 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.16059904 |
|---|---|
| Minimum | -6.075 |
| Maximum | 9.225 |
| Zeros | 4330986 |
| Zeros (%) | 52.7% |
| Memory size | 62.7 MiB |
Quantile statistics
| Minimum | -6.075 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 3.675 |
| 95-th percentile | 6.3 |
| Maximum | 9.225 |
| Range | 15.3 |
| Interquartile range (IQR) | 3.675 |
Descriptive statistics
| Standard deviation | 2.434841666 |
|---|---|
| Coefficient of variation (CV) | 1.126928977 |
| Kurtosis | -1.328236337 |
| Mean | 2.16059904 |
| Median Absolute Deviation (MAD) | 2.276835756 |
| Skewness | 0.4855266553 |
| Sum | 17763486 |
| Variance | 5.928453937 |
| Value | Count | Frequency (%) | |
| 0 | 4330986 | 52.7% | |
| 3.6 | 621594 | 7.6% | |
| 3.675 | 480267 | 5.8% | |
| 3.525 | 458682 | 5.6% | |
| 3.45 | 341068 | 4.1% | |
| 6.15 | 238980 | 2.9% | |
| 6.525 | 231203 | 2.8% | |
| 6.075 | 208359 | 2.5% | |
| 6 | 154957 | 1.9% | |
| 6.225 | 130338 | 1.6% | |
| Other values (96) | 1025122 | 12.5% |
| Value | Count | Frequency (%) | |
| -6.075 | 2 | < 0.1% | |
| -5.175 | 2 | < 0.1% | |
| -3.975 | 2 | < 0.1% | |
| -0.375 | 2 | < 0.1% | |
| 0 | 4330986 | 52.7% |
| Value | Count | Frequency (%) | |
| 9.225 | 2 | < 0.1% | |
| 7.5 | 30 | < 0.1% | |
| 7.425 | 3 | < 0.1% | |
| 7.35 | 15 | < 0.1% | |
| 7.275 | 17 | < 0.1% |
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 2 |
| Missing (%) | < 0.1% |
| Memory size | 62.7 MiB |
| 1 | |
|---|---|
| 0 | 493223 |
| (Missing) | 2 |
| Value | Count | Frequency (%) | |
| 1 | 7728331 | 94.0% | |
| 0 | 493223 | 6.0% | |
| (Missing) | 2 | < 0.1% |
| Distinct count | 1 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 62.7 MiB |
| 0 |
|---|
| Value | Count | Frequency (%) | |
| 0 | 8221556 | 100.0% |
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 62.7 MiB |
| 1 | |
|---|---|
| 0 | 507139 |
| Value | Count | Frequency (%) | |
| 1 | 7714417 | 93.8% | |
| 0 | 507139 | 6.2% |
WAR_SYS_3
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 62.7 MiB |
| 0 | |
|---|---|
| 1 | 3 |
| Value | Count | Frequency (%) | |
| 0 | 8221553 | > 99.9% | |
| 1 | 3 | < 0.1% |
| Distinct count | 1016 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 109.8274322 |
|---|---|
| Minimum | 0 |
| Maximum | 537.3 |
| Zeros | 259639 |
| Zeros (%) | 3.2% |
| Memory size | 62.7 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 79.3125 |
| Q1 | 92.475 |
| median | 100.2375 |
| Q3 | 136.35 |
| 95-th percentile | 156.9375 |
| Maximum | 537.3 |
| Range | 537.3 |
| Interquartile range (IQR) | 43.875 |
Descriptive statistics
| Standard deviation | 33.32104555 |
|---|---|
| Coefficient of variation (CV) | 0.3033945607 |
| Kurtosis | 2.833154087 |
| Mean | 109.8274322 |
| Median Absolute Deviation (MAD) | 25.15502502 |
| Skewness | -0.6126988129 |
| Sum | 902952384.3 |
| Variance | 1110.292077 |
| Value | Count | Frequency (%) | |
| 0 | 259639 | 3.2% | |
| 93.15 | 131180 | 1.6% | |
| 93.4875 | 129894 | 1.6% | |
| 92.8125 | 128664 | 1.6% | |
| 93.825 | 128552 | 1.6% | |
| 92.475 | 127406 | 1.5% | |
| 94.1625 | 125224 | 1.5% | |
| 92.1375 | 125123 | 1.5% | |
| 91.8 | 121827 | 1.5% | |
| 94.5 | 121147 | 1.5% | |
| Other values (1006) | 6822900 | 83.0% |
| Value | Count | Frequency (%) | |
| 0 | 259639 | 3.2% | |
| 2.3625 | 55 | < 0.1% | |
| 2.7 | 95 | < 0.1% | |
| 3.0375 | 343 | < 0.1% | |
| 3.375 | 191 | < 0.1% |
| Value | Count | Frequency (%) | |
| 537.3 | 4 | < 0.1% | |
| 392.5125 | 4 | < 0.1% | |
| 388.8 | 4 | < 0.1% | |
| 387.7875 | 4 | < 0.1% | |
| 384.75 | 4 | < 0.1% |
| Distinct count | 944 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 109.7345003 |
|---|---|
| Minimum | 0 |
| Maximum | 393.525 |
| Zeros | 159703 |
| Zeros (%) | 1.9% |
| Memory size | 62.7 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 81.675 |
| Q1 | 92.475 |
| median | 100.2375 |
| Q3 | 133.65 |
| 95-th percentile | 156.9375 |
| Maximum | 393.525 |
| Range | 393.525 |
| Interquartile range (IQR) | 41.175 |
Descriptive statistics
| Standard deviation | 30.8554218 |
|---|---|
| Coefficient of variation (CV) | 0.281182506 |
| Kurtosis | 2.682709994 |
| Mean | 109.7345003 |
| Median Absolute Deviation (MAD) | 23.59240749 |
| Skewness | -0.3911270892 |
| Sum | 902188339.6 |
| Variance | 952.0570545 |
| Value | Count | Frequency (%) | |
| 0 | 159703 | 1.9% | |
| 92.475 | 132622 | 1.6% | |
| 92.1375 | 132620 | 1.6% | |
| 92.8125 | 131502 | 1.6% | |
| 93.15 | 131134 | 1.6% | |
| 91.8 | 129090 | 1.6% | |
| 93.4875 | 128164 | 1.6% | |
| 91.4625 | 127630 | 1.6% | |
| 93.825 | 124729 | 1.5% | |
| 91.125 | 121613 | 1.5% | |
| Other values (934) | 6902749 | 84.0% |
| Value | Count | Frequency (%) | |
| 0 | 159703 | 1.9% | |
| 3.0375 | 284 | < 0.1% | |
| 3.375 | 640 | < 0.1% | |
| 3.7125 | 594 | < 0.1% | |
| 4.05 | 811 | < 0.1% |
| Value | Count | Frequency (%) | |
| 393.525 | 4 | < 0.1% | |
| 392.5125 | 4 | < 0.1% | |
| 388.125 | 8 | < 0.1% | |
| 385.425 | 4 | < 0.1% | |
| 373.95 | 4 | < 0.1% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
First rows
| AC | FLIGHT | TIME | AMBIENT_1 | PAR_AC_1 | PAR_AC_2 | PAR_AC_3 | PAR_AC_4 | PAR_SYS_1 | PAR_SYS_2 | PAR_SYS_3 | PAR_SYS_4 | WAR_SYS_1 | COM_SYS_1 | PAR_SYS_9 | PAR_SYS_10 | PAR_SYS_5 | WAR_SYS_2 | PAR_SYS_6 | WAR_SYS_3 | PAR_SYS_7 | PAR_SYS_8 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | AC19 | 006042 | 0 | 11720.0 | 44.18250 | 40.92875 | 0 | 0 | 69.000 | 285.0 | 63.625 | 285 | 0 | 0 | 0.0 | 0.0 | 1.0 | 0 | 1 | 0 | 225.7875 | 132.300 |
| 1 | AC19 | 006042 | 1 | 11720.0 | 42.98375 | 40.07250 | 0 | 0 | 69.000 | 287.0 | 63.625 | 285 | 0 | 0 | 0.0 | 0.0 | 1.0 | 0 | 1 | 0 | 225.7875 | 132.300 |
| 2 | AC19 | 006042 | 2 | 11720.5 | 42.98375 | 40.07250 | 0 | 0 | 69.000 | 287.0 | 63.625 | 285 | 0 | 0 | 0.0 | 0.0 | 1.0 | 0 | 1 | 0 | 112.7250 | 132.300 |
| 3 | AC19 | 006042 | 3 | 11720.5 | 42.98375 | 40.07250 | 0 | 0 | 67.500 | 287.0 | 63.625 | 285 | 0 | 0 | 0.0 | 0.0 | 1.0 | 0 | 1 | 0 | 112.7250 | 124.875 |
| 4 | AC19 | 006042 | 3060 | 11724.0 | 0.00000 | 0.00000 | 0 | 0 | 66.625 | 246.0 | 59.875 | 228 | 0 | 0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 79.6500 | 0.000 |
| 5 | AC19 | 006042 | 3061 | 11724.0 | 0.00000 | 0.00000 | 0 | 0 | 66.625 | 246.0 | 59.875 | 228 | 0 | 0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 79.6500 | 0.000 |
| 6 | AC19 | 006042 | 3062 | 11724.5 | 0.00000 | 0.00000 | 0 | 0 | 66.625 | 246.0 | 59.875 | 249 | 0 | 0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0.0000 | 0.000 |
| 7 | AC19 | 006042 | 3063 | 11724.5 | 0.00000 | 0.00000 | 0 | 0 | 66.250 | 246.0 | 59.875 | 249 | 0 | 0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0.0000 | 0.000 |
| 8 | AC19 | 006042 | 3064 | 11725.0 | 0.00000 | 0.00000 | 0 | 0 | 66.250 | 246.0 | 60.375 | 249 | 0 | 0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0.0000 | 0.000 |
| 9 | AC19 | 006042 | 3065 | 11724.5 | 0.00000 | 0.00000 | 0 | 0 | 66.250 | 246.0 | 60.375 | 249 | 0 | 0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 0.0000 | 0.000 |
Last rows
| AC | FLIGHT | TIME | AMBIENT_1 | PAR_AC_1 | PAR_AC_2 | PAR_AC_3 | PAR_AC_4 | PAR_SYS_1 | PAR_SYS_2 | PAR_SYS_3 | PAR_SYS_4 | WAR_SYS_1 | COM_SYS_1 | PAR_SYS_9 | PAR_SYS_10 | PAR_SYS_5 | WAR_SYS_2 | PAR_SYS_6 | WAR_SYS_3 | PAR_SYS_7 | PAR_SYS_8 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8221546 | AC36 | ffa91e | 5068 | 12192.5 | 0.0 | 0.0 | 0 | 0 | 66.625 | 287.0 | 62.375 | 254 | 0 | 0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 130.6125 | 151.2000 |
| 8221547 | AC36 | ffa91e | 5069 | 12192.5 | 0.0 | 0.0 | 0 | 0 | 66.625 | 287.0 | 64.625 | 254 | 0 | 0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 130.6125 | 151.2000 |
| 8221548 | AC36 | ffa91e | 5070 | 12192.5 | 0.0 | 0.0 | 0 | 0 | 66.625 | 289.0 | 64.625 | 254 | 0 | 0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 130.6125 | 151.2000 |
| 8221549 | AC36 | ffa91e | 5071 | 12192.5 | 0.0 | 0.0 | 0 | 0 | 66.625 | 289.0 | 64.625 | 256 | 0 | 0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 137.0250 | 151.2000 |
| 8221550 | AC36 | ffa91e | 5072 | 12192.5 | 0.0 | 0.0 | 0 | 0 | 67.500 | 289.0 | 64.625 | 256 | 0 | 0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 137.0250 | 98.8875 |
| 8221551 | AC36 | ffa91e | 5073 | 12192.5 | 0.0 | 0.0 | 0 | 0 | 67.500 | 289.0 | 64.625 | 256 | 0 | 0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 137.0250 | 98.8875 |
| 8221552 | AC36 | ffa91e | 5074 | 12192.5 | 0.0 | 0.0 | 0 | 0 | 67.500 | 290.0 | 64.625 | 256 | 0 | 0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 137.0250 | 98.8875 |
| 8221553 | AC36 | ffa91e | 5075 | 12192.5 | 0.0 | 0.0 | 0 | 0 | 67.500 | 290.0 | 64.625 | 257 | 0 | 0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 134.6625 | 98.8875 |
| 8221554 | AC36 | ffa91e | 5076 | 12192.5 | 0.0 | 0.0 | 0 | 0 | 66.000 | 290.0 | 64.625 | 257 | 0 | 0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 134.6625 | 112.7250 |
| 8221555 | AC36 | ffa91e | 5077 | 12192.5 | 0.0 | 0.0 | 0 | 0 | 66.000 | 290.0 | 62.375 | 257 | 0 | 0 | 0.0 | 0.0 | 0.0 | 0 | 0 | 0 | 134.6625 | 112.7250 |